<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
    <%@ taglib prefix="s" uri="/struts-tags"%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%> 
<!DOCTYPE html>
<html>
	<head>
		<meta charset="UTF-8">
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<title></title>
		<link rel="stylesheet" href="../assets/css/layui.css">
	    <link rel="stylesheet" href="../assets/css/view.css"/>
	    <link rel="stylesheet" href="../assets/css/style.css"/>
	</head>
	<body class="layui-tank">
		 <div class="layui-card">
		 	   <form class="layui-form" action="">
				   <div class="layui-form-item">
					    <label class="layui-form-label">用户名</label>
					    <div class="layui-input-block">
					        <input type="text" name="title" lay-verify="title" autocomplete="off" placeholder="" class="layui-input">
					    </div>					    
					</div>
					<div class="layui-form-item">
					    <label class="layui-form-label">账号</label>
					    <div class="layui-input-block">
					        <input type="text" name="title" lay-verify="title" autocomplete="off" placeholder="" class="layui-input">
					    </div>					    
					</div>
					<div class="layui-form-item layui-form-text">
					    <label class="layui-form-label">密码</label>
					    <div class="layui-input-block">
					         <input type="text" name="title" lay-verify="title" autocomplete="off" placeholder="" class="layui-input">
					    </div>
					</div>
					<sql:setDataSource var="snapshot" driver="com.mysql.cj.jdbc.Driver"
                    url="jdbc:mysql://localhost:3306/equipmentmgr?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true"
                    user="root" password="123456" />
                    <sql:query dataSource="${snapshot}" var="role">
                     SELECT  *  FROM `d_role`  
                   </sql:query>
                    <sql:query dataSource="${snapshot}" var="user">
                     SELECT  *  FROM `d_user`  where user_role = 
                   </sql:query>
					<div class="layui-form-item layui-form-text">
					    <div class="layui-form-item">
							    <label class="layui-form-label">角色</label>
							    <div class="layui-input-block">
							      <select name="interest" lay-filter="aihao">
							       <option value="0">未选</option>
							        <c:forEach var="juese" items="${role.rows}">
							        <option value="${juese.ID}"><c:out value="${juese.name}"/></option>
		                                 </c:forEach>
							      </select>
							    </div>						    
						  </div>
					    
					</div>
					
				</form>				
		 </div>
		 <div class=" tkbtnfxd">
	    	<button type="button" class="layui-btn  layui-btn-normal float-right">确定</button>
	        <button type="button" class="layui-btn layui-btn-primary float-right">取消</button>
	    </div>
	    
	<script src="../assets/layui.all.js"></script>    
	
	</body>
</html>
